<%@page import="java.sql.*,online.*,java.util.*,java.lang.*,studentportal.*"%>
<%jsp:useBean id="mysql" class="studentportal.MySQLDriver" scope="session"/>
<html>
<body>
<%!
         Connection con=null;
         Statement st=null;
         ResultSet rs=null;
         int id=0;
         int i=0;
         int j=0;
		 String ss="10";
%>
	
<p>&nbsp;
<p>&nbsp;
<p>&nbsp;
<TABLE bgcolor="#006699" border=0  width=760>
<tr align="right" align="center">	
	<td align="center" width="782" valign="center">
     <!--mstheme--><font face="Arial, Helvetica"><b>Faculty Assignmernt  Information&nbsp;</b><!--mstheme--></font>
	</td>
	  <td width="6%" nowrap bordercolor="#006699" bgcolor="#006699" height="1"><!--mstheme--><font face="Arial, Helvetica"><div align="right"><strong><a href="Home.html"><font color="#FFFFA4">Home</font></a></strong></div><!--mstheme--></font></td>
</tr>
</table>
<!--mstheme--><font face="Arial, Helvetica">
</form>
<table border="1"  cellpadding="1" cellspacing="1" bordercolor="#006699" align="center">
    
	<tr>
		<th>Assignment No</th>
		<th>Faculty ID</th>		
		<th>Assignment Date</th>
		<th>Last Date of Submission</th>		
		<th>Subject ID</th>
		<th>Question Desciption</th>


		<%
				con=mysql.getConnection();
				st=con.createStatement();
			a	rs=st.executeQuery("select * from faculty_assignment where assignment_no='"+request.getParameter("AID")+"'");
				while(rs.next())
				{
		%>
		<tr>
			<td><%=rs.getString(1)%></td>
			<td><%=rs.getString(2)%></td>
		    <td><%=rs.getDate(3)%></td>
			<td><%=rs.getDate(4)%></td>
			<td><%=rs.getString(5)%></td>
			<td><%=rs.getString(6)%></td>			
	 </tr>	
		<%
				}
		%>
 </table>
</body>
</html>
	